package com.dwjm.shop.merchant;

import com.dwjm.shop.goods.Goods;
import com.dwjm.shop.utils.ConnectionDatabaseForMySQLUseJdbc;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;



public class MerchantDaoImpl implements MerchantDao {
    Connection connection= null;
    PreparedStatement pstmt= null;
    ResultSet rset = null;
    public MerchantDaoImpl() {
        connection = ConnectionDatabaseForMySQLUseJdbc.getConnection();


}



    @Override
    public boolean login(String account, String password) {
        try{
            System.out.println("xxxxxxxxxxxxxxxxxxxxxxxxx");
            pstmt = connection.prepareStatement("select account from t_merchant where account= ? and password = ?");
            pstmt.setString(1, account);
            pstmt.setString(2, password);
            rset = pstmt.executeQuery();

            if(rset.next()){
                return true;
            }
        }catch(Exception e){
            e.printStackTrace();
        }
        return false;
    }



    @Override
    public int addGoods(Goods goods) {
        try{
                 pstmt = connection.prepareStatement("insert into t_goods(title,price,desc,img,state,mid) value(?,?,?,?,?,?)");
                 pstmt.setString(1, goods.getTitle());
                 pstmt.setBigDecimal(2, goods.getPrice());
                 pstmt.setString(3, goods.getDesc());
                 pstmt.setString(4, goods.getImg());
                 pstmt.setInt(5, 0);
                 pstmt.setInt(6, goods.getMid());
                 int i = pstmt.executeUpdate();
                 return i ==1 ? 1 : 0;
        }catch(Exception e){
            e.printStackTrace();
        }
        return 0;
    }
}

